Inquiry by Invoice and Line - CDR 2

Associated Files

This program shows the effects of Cost Drivers on the costs and gross profits of any invoice number/line. The effects include a complete cost breakdown that shows the before and after effect the Cost Driver had on the gross profit of that line.

Enter the Company number, Invoice number, and Line number for the invoice or line you want to display. The Cost Driver Detail Inquiry screen appears.

This screen shown above displays the price and cost before the effect of the Cost Drivers, followed by a list of all Cost Drivers accrued against the invoice/line. The bottom portion of the screen shows the total effect of the Cost Driver accruals on the unit cost and extended cost. The adjusted gross profit percentage is also shown; first considering only the GP Drivers, and then considering all Cost Drivers.

The Total That Affects Cost & GP figure will always agree with the GP% that is shown on the Invoice Inquiry Detail Line screen, and on all sales reports using the default GP settings of the system. The Total That Affects Cost & GP figure includes the product cost, any promo file rebates, and Cost Drivers that have been coded to affect GP. The Total of All Cost Drivers figure is the bottom line net profit percentage, including the effect of even the Non-GP Cost Drivers.

Associated Files